package com.sxbbc.common.core.mapper.jz;

import com.sxbbc.common.core.entity.jz.WWarehouse;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 仓库信息表 Mapper 接口
 * </p>
 *
 * @author leehao
 * @since 2019-07-01
 */
public interface WWarehouseMapper extends BaseMapper<WWarehouse> {

    /**
     * 根据商品查询可用的仓库
     * @param proCode 商品编码
     * @param skuId 商品详情ID
     * @param qty 数量
     * @author leehao
     */
    List<WWarehouse> queryWarehouseByProduct(@Param("proCode") String proCode,
                         @Param("skuId") Integer skuId,@Param("qty") Integer qty);
}
